ExecuteArray(Int32,Int64[]) Method

In This Topic

Executes SQL statement specified number of times. Returns the numbers of rows affected for each array element in its out parameter. Supported only for Oracle 12c Release 1 (12.1) - both server and client.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function ExecuteArray( _
   ByVal iters As Integer, _
   ByRef rowsAffected() As Long _
) As Integer

public int ExecuteArray( 
   int iters,
   out long[] rowsAffected
)

Parameters

iters: Number of times to execute SQL statement.
rowsAffected: Returns the numbers of rows affected for each array element.

Return Value

The return value is the number of rows affected by the statement.

Remarks

The ExecuteArray method allows to execute several SQL statements for the one time. The main advantage of using this method is that only one round trip to the server is used to execute several queries, which speeds up queries execution compared to consecutive invocation.

All parameters of the query must have System.Array type and an elements of the array must have type corresponding to the type of the parameter. The value of the iters parameter must be equal to the number of elements of the array.

Refer to "Working with Array Binding" article for detailed information and example.

Reference

OracleCommand Class
OracleCommand Members
Overload List

Send Feedback